/*
 Navicat Premium Data Transfer

 Source Server         : one
 Source Server Type    : MySQL
 Source Server Version : 50730
 Source Host           : localhost:3306
 Source Schema         : bbs

 Target Server Type    : MySQL
 Target Server Version : 50730
 File Encoding         : 65001

 Date: 26/12/2021 12:53:31
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for appuser
-- ----------------------------
DROP TABLE IF EXISTS `appuser`;
CREATE TABLE `appuser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(30) DEFAULT NULL COMMENT '用户名',
  `account` varchar(20) DEFAULT NULL COMMENT '账号',
  `password` varchar(20) DEFAULT NULL COMMENT '密码',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `introduce` varchar(255) DEFAULT NULL COMMENT '个人简介',
  `hobby` varchar(255) DEFAULT NULL COMMENT '爱好',
  `email` varchar(30) DEFAULT NULL COMMENT '邮箱',
  `activation` int(1) DEFAULT NULL COMMENT '0未激活1激活',
  `sex` int(1) DEFAULT NULL COMMENT '0未知1男2女',
  `puid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=322 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of appuser
-- ----------------------------
BEGIN;
INSERT INTO `appuser` VALUES (111, 'zhangsan', NULL, 'mima', '0099-12-27', NULL, NULL, NULL, NULL, 1, 123);
INSERT INTO `appuser` VALUES (123, 'zhangsan', NULL, '123', '2021-12-27', NULL, NULL, NULL, NULL, 1, 123);
INSERT INTO `appuser` VALUES (321, 'lisi', NULL, '123', '2021-12-27', NULL, NULL, NULL, NULL, 1, 123);
COMMIT;

-- ----------------------------
-- Table structure for posts
-- ----------------------------
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL COMMENT '帖子标题',
  `content` varchar(255) DEFAULT NULL COMMENT '帖子内容',
  `view_count` varchar(255) DEFAULT NULL COMMENT '查看次数',
  `release_time` datetime DEFAULT NULL COMMENT '发布时间',
  `last_time` datetime DEFAULT NULL COMMENT '最后回复时间',
  `user_id` varchar(32) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of posts
-- ----------------------------
BEGIN;
INSERT INTO `posts` VALUES (1, '1111', '2222', '3333', '2021-12-11 21:33:18', '2021-12-11 21:33:22', '123');
INSERT INTO `posts` VALUES (2, '1111', '2222', '3333', '2021-12-11 21:33:18', '2021-12-11 21:33:22', '123');
INSERT INTO `posts` VALUES (5, '阿西吧', '斯密达', NULL, '2021-12-13 08:41:23', '2021-12-13 08:41:23', '123');
INSERT INTO `posts` VALUES (6, 'asd', 'dsa', NULL, '2021-12-13 08:47:48', '2021-12-13 08:47:48', '123');
INSERT INTO `posts` VALUES (7, '哈哈哈哈哈', '嘻嘻嘻嘻嘻', NULL, '2021-12-20 06:31:38', '2021-12-20 06:31:38', '321');
INSERT INTO `posts` VALUES (8, 'lisi阿西吧', '斯密达', NULL, '2021-12-13 08:41:23', '2021-12-13 08:41:23', '321');
INSERT INTO `posts` VALUES (9, 'lisiasd阿西吧', '斯密达', NULL, '2021-12-13 08:41:23', '2021-12-13 08:41:23', '321');
COMMIT;

-- ----------------------------
-- Table structure for reply
-- ----------------------------
DROP TABLE IF EXISTS `reply`;
CREATE TABLE `reply` (
  `id` varchar(32) NOT NULL,
  `reply_time` datetime DEFAULT NULL COMMENT '回复时间',
  `content` varchar(500) DEFAULT NULL COMMENT '回复内容',
  `user_id` varchar(32) DEFAULT NULL COMMENT '用户id',
  `post_id` varchar(32) DEFAULT NULL COMMENT '帖子id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of reply
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
